Sales By Location 18

1.Open a new sheet

2.  Click on Format and select shading and select sheet>worksheet and select color #e8edda



3. Drag and drop State to Details under Marks

4. Drag and drop Sales to color and total volume, and average price in tool tip under marks card. Right click Average Price and select measure> Average




5. Select Map in the menu bar select Background maps > Normal.



6. Click on Map layers uncheck everything and only keep Country/Region Names, Country/Region Borders ,  State/ Province borders and Sate/Province Name.



7. Select legend at the right side and right click > select Edit colors > in the popup window select for the palette select Green color . Clock OK.





8. Right click Sum sales color under marks and select Format > Pane >Numbers(Custom) > decimal Places 2 , Display Units Millions , Prefix as $.

Similarly select  right click Total Volume and select Format > Pane >Numbers(Custom) > decimal Places 2 , Display Units Millions .

Again select Average right click and select Format > Pane >Numbers(Custom) > decimal Places 2 ,Prefix as $.








9. Select the Title and rt select Edit Title > Erase the text and type  Sales By Location Change the font to Tableau Semi bold > Font size to 10 > Font Color Black >Alignment Center.



10. Increase/ Decrease the size of Map using the + and  - control in the Map



Maps in Tableau :

https://www.youtube.com/watch?v=X0n0s0gzcvE